Tags: ann from warnings column Insert name tab can records
INSERT into table-name values ()
Mysql>desc NS;+-------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key |Default|
Extra | +-------+------------------+------+-----+---------+----------------+
| UID | Int (Ten) unsigned | NO | PRI | NULL | auto_increment | | uname | varchar (20) | NO | | NULL | |
| udate | Date | YES |
tool we need. Unzip the tool into a directory, assuming the D:\common-path\UnxUtils directory, add the D:\common-path\UnxUtils\usr\local\wbin of those tools to the system's environment variable path, Can be added to the last. Because there is a date built-in command in the Windows platform, you need to rename the Unxutils Date.exe to something else, such as Udate.exe instead. Open the console with CMD and enter:D:\>udate-d "Yesterday" +%y-%m-%d2010-0
SourceForge to download the unxutils tool. Unxutils is a very powerful tool set. It transplanted most Linux commands to the Windows platform, for example, ls, grep, WC, and other 120 commands, of course, this includes the date tool we need. Decompress the tool to a directory. Assume that the tool is in the D: \ common-path \ unxutils directory: \ common-path \ unxutils \ USR \ Local \ wbin is added to the system environment variable path, which can be added to the end. Because the Windows platf
As the Treasurer knows, the date of the transfer check is to be capitalized. If you use handwriting, of course, you can directly fill in the upper case, but if the design of special software to play, each check in a fixed position to fill in the capitalization will be cumbersome and unnecessary. Here only to access2007 design as an example, to this aspect of enthusiasts to provide a way of thinking.
First, design a Access2007 table, add the transfer cheque may need fields, such as the payer nam
As the Treasurer knows, the date of the transfer check is to be capitalized. If you use handwriting, of course, you can directly fill in the upper case, but if the design of special software to play, each check in a fixed position to fill in the capitalization will be cumbersome and unnecessary. Here only to Access2007 design as an example, to this aspect of enthusiasts to provide a way of thinking.
First, design a Access2007 table, add the transfer cheque may need fields, such as the payer nam
=" Org.springframework.web.servlet.i18n.LocaleChangeInterceptor " /> " Localeresolver"class=" Org.springframework.web.servlet.i18n.SessionLocaleResolver" /> In the current directory, add the following files, Messages.properties, messages_zh_cn.properties, messages_en_us.properties three files, of which messages.properties , Messages_zh_cn.properties;Messages_en_us.properties:umoney=moneyudate=dateMessages_zh_cn.properties:umoney= balance udate
sqldatetoutildate (Java.sql.Date sdate)
{
Java.util.Date udate = null;
Long T = Sdate.gettime ();
Udate = new Date (t);
return udate;
}
public static Java.sql.Date utildatetosqldate (Java.util.Date udate)
{
Java.sql.Date sdate = null;
Long T = Udate.gettime ();
Sdate = new Java.sql.Date (t);
return sdate;
}
public st
Java. util. Date and Java. SQL. Date, java. SQL. Time, java. SQL. Timestamp interchange, java. SQL. timestamp
1. SQL time type to util time type
Principle: java. SQL. date, java. SQL. time, java. SQL. the three Timestamp classes are java. util. date subclass, so according to the design principle of polymorphism, the parent class reference points to the subclass object and can be directly converted.
That is:
Java. util. Date uDate = new java. SQL. Date
1. SQL Time type go util time typePrinciple: Java.sql.Date, Java.sql.Time, java.sql.Timestamp three classes are java.util.Date subclasses, so according to the design principle of polymorphism, the parent class refers to the sub-class object, can be directly converted.ThatJava.util.Date udate = new Java.sql.Date (0);Or: java.util.Date udate = new Java.sql.Time (0);Or: java.util.Date
..... on duplicate key update, mysql> insert into t1 (a, B) select '3', 'r5 'on duplicate key update B = 'r5'; Query OK, 2 rows affected, 1 warning (0.19 sec) Records: 1 Duplicates: 1 Warnings: 1 mysql> select * from t1; + --- + ---- + | a | B | c | + --- + ---- + | 1 | c3 | c2 | 2 | a | 3 | r5 | r3 | 5 | r4 | r5 | + --- + ---- + 4 rows in set (0.00 sec) [] When a = 5, the original c value is still there, which means that when the key is sometimes, only The subsequent
1. What is an objectAll things in JavaScript are objects, such as strings, numbers, arrays, functions, and so on, each with properties and methods.Object properties: Reflect the object of certain specific properties, such as: the length of the string, the image of the long width, etc.;Object: An action that can be performed on an object. For example, the form "submit" (submit), the time of "get" (getYear), etc.;JavaScript provides a number of built-in objects, such as String, Date, array, and so
value will be: 6
Ways to Access Objects:
objectName.methodName()
Use the toUpperCase () method of the String object to convert text to uppercase:
var mystr= "Hello world!"; /Create a String
var request=mystr.touppercase ();//Use String object method
After the above code executes, the value of the request is: HELLO world!
Date Date Object
Date objects can store any one date, and can be accurate to milliseconds (1/1000 seconds).
Define a Time object:
var
js| Security | process | cracking
One day on the internet accidentally opened a website, there is plmm and you video chat, but to mobile phone registration fees. Just want to find if there is a loophole can not spend money on the chat with MM. First find there is no SQL loophole can be drilled, open a page with parameters, http://www.xxx.yyy/abc.jsp?agentid=111116, the back of the parameters to try to http://www.xxx.yyy/abc.jsp? agentid=111116 ' Result:
Servlet ExceptionJava.lang.NumberFormatExc
field, will automatically fill the default value.
2.1 OK, and then see INSERT INTO ... on duplicate key update,
mysql> INSERT INTO T1 (a,b) Select ' 3 ', ' R5 ' on duplicate key update b= ' R5 ';
Query OK, 2 rows affected, 1 Warning (0.19 sec)
records:1 duplicates:1 warnings:1 mysql>
select * from t1;
+---+----+----+
| a | b
| +---+----+----+
| 1 | c3 | c2 |
| 2 | A | | |
3 | R5 | R3 |
| 5 | R4 | R5 |
+---+----+----+
4 rows in Set (0.00 sec)
"" A=5 time, the original C value is
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.